-- 应急预案关联资源字段长度调整
ALTER TABLE [dbo].[t_contingency_plan_resources] ALTER COLUMN [name] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ALTER COLUMN [resource] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    GO

ALTER TABLE [dbo].[t_contingency_plan_resources] ALTER COLUMN [address] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

-- 积水点新增字段
ALTER TABLE [dbo].[t_pond] ADD [technical] nvarchar(255) NULL
    GO

ALTER TABLE [dbo].[t_pond] ADD [technical_phone] nvarchar(255) NULL
    GO
    EXEC sp_addextendedproperty
    'MS_Description', N'技术专家',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond',
    'COLUMN', N'technical'
    GO
    EXEC sp_addextendedproperty
    'MS_Description', N'技术专家电话',
    'SCHEMA', N'dbo',
    'TABLE', N't_pond',
    'COLUMN', N'technical_phone'

Alter table t_contingency_plan Alter column name nvarchar(1000)
